SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 70059: Removing configuration of SAS® Factory Miner 15.2 removes the SharedServices entry from the SASServer11_1/conf/server.xml file

DetailsAboutRate It

As a result of removing the SharedServices connection entry from the SASServer11_1/conf/server.xml file, the web applications (if deployed on SASServer11) for the following will not be able to start:

  • SAS® Model Manager
  • SAS® Enterprise Miner™
  • SAS® Forecast Server

The SharedServices connection is incorrectly removed from the server.xml file because, during the Removing Existing Configuration step, SAS Factory Miner sets the /Lev#/Web/Scripts/AppServer/props/appserver.properties for SASServer11 and the following strings are left:

datasource.##.isDeleted=false
datasource.##.jndiName=sas/jdbc/DMServices

It also changes ShareServices, isDeleted=true:

datasource.17.isDeleted=true
datasource.17.jndiName=sas/jdbc/SharedServices

In the Lev#/Web/Logs/SASServer11*/server.log, these errors are generated at the start:

| ERROR | [ContextLoader] | Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.sas.svcs.springframework.config.DefaultProvidedPropertyPlaceholderConfigurer#0': Cannot resolve reference to bean 'environmentProperties' while setting bean property 'properties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'environmentProperties': Cannot resolve reference to bean 'datasource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'datasource': Invocation of init method failed; nested exception is javax.naming.NameNotFoundException: Name [jdbc/SASAPP] is not bound in this Context. Unable to find [jdbc].

As a result of the app.servers file having isDeleted=false for the DMServices database, this connection information is not removed from the server.xml file:

<Resource auth="Container" driverClassName="org.postgresql.Driver" factory="com.sas.vfabrictcsvr.atomikos.BeanFactory" localTransactionMode="true" maxPoolSize="250" minPoolSize="10" name="sas/jdbc/DMServices" password="${pw.sas.jdbc.DMServices}" testQuery="select 1" type="com.atomikos.jdbc.nonxa.AtomikosNonXADataSourceBean" uniqueResourceName="sas/jdbc/DMServices" url="jdbc:postgresql://sas-aap.demo.sas.com:10432/DMServices" user="DMServices"/>

A hot fix is planned for this issue.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS Factory MinerMicrosoft® Windows® for x64
Microsoft Windows 8 Enterprise 32-bit
Microsoft Windows 8 Enterprise x64
Microsoft Windows 8 Pro 32-bit
Microsoft Windows 8 Pro x64
Microsoft Windows 8.1 Enterprise 32-bit
Microsoft Windows 8.1 Enterprise x64
Microsoft Windows 8.1 Pro 32-bit
Microsoft Windows 8.1 Pro x64
Microsoft Windows 10
Microsoft Windows 11
Microsoft Windows 95/98
Microsoft Windows 2000 Advanced Server
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows NT Workstation
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 for x64
Microsoft Windows Server 2008
Microsoft Windows Server 2008 R2
Microsoft Windows Server 2008 for x64
Microsoft Windows Server 2012 Datacenter
Microsoft Windows Server 2012 R2 Datacenter9.4 TS1M8
Microsoft Windows Server 2012 R2 Std9.4 TS1M8
Microsoft Windows Server 2012 Std
Microsoft Windows Server 20169.4 TS1M8
Microsoft Windows Server 20199.4 TS1M8
Microsoft Windows Server 2022
Microsoft Windows XP Professional
Windows 7 Enterprise 32 bit
Windows 7 Enterprise x64
Windows 7 Home Premium 32 bit
Windows 7 Home Premium x64
Windows 7 Professional 32 bit
Windows 7 Professional x64
Windows 7 Ultimate 32 bit
Windows 7 Ultimate x64
Windows Millennium Edition (Me)
Windows Vista
Windows Vista for x64
64-bit Enabled AIX9.4 TS1M8
64-bit Enabled Solaris
HP-UX IPF9.4 TS1M8
Linux for x649.4 TS1M8
Solaris for x64
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.